package com.company.dao;



import com.company.entity.Phone;

import java.sql.SQLException;
import java.util.List;

public interface  PhoneDAO {

    List<Phone> queryByUserId(int userid);
//        String sql = "select * from phone where userid=?";


    void add(Phone p);
//        String sql = "insert into phone(name,tel,userid) values (?,?,?)";


    void del(int pid);
//        String sql = "delete from phone where id=? and userid=?";


    Phone queryPhone(int pid);
//        String sql = "select * from phone where id=? and userid=?";


    void editPhone(Phone p);
//        String sql = "update phone set name=?,tel=? where id=? and userid=?";

}
